UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'UpP4nPNxH4YHPcMNbPKKJy163AbuG/UxCwRX0Xg54aM='
WHERE
key_id = 'cb96504d50767c9f575dfc1974f69764773c32ce52a047ce4f5ce674b24d4dc5'
AND (
token = 'UpP4nPNxH4YHPcMNbPKKJy163AbuG/UxCwRX0Xg54aM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)