UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'VmI5R4dMh6N64qEYDSGG7jXvJkpd8bWVwpYYVd/CtP4='
WHERE
key_id = '78a8afc1c6ed2e6b43d8c368a3820830deda88bdb208fb101caba9f84c96457b'
AND (
token = 'VmI5R4dMh6N64qEYDSGG7jXvJkpd8bWVwpYYVd/CtP4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)