UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'U+zqT+4CTDTV3O0CcWcVfP0cc93I9eOz/3EkpmjYpZE='
WHERE
key_id = 'a9ef850c250fb925f976e6119243ff23f3303771ceaa66c0670427932f434811'
AND (
token = 'U+zqT+4CTDTV3O0CcWcVfP0cc93I9eOz/3EkpmjYpZE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)