UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'X9fPI5FcDJ6JH95MYXk4FPDiSXHIO3vkJe29QghOYdI='
WHERE
key_id = 'cb0ae8c6891a93e2f4c95a56a729737aba5441592078b60ecddeec203f615f8f'
AND (
token = 'X9fPI5FcDJ6JH95MYXk4FPDiSXHIO3vkJe29QghOYdI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)