UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9r8YGVkaaLuuCUzgftVBu0+nwIkYCZsghld+EEP/DzI='
WHERE
key_id = '156186663e1bd3f998fa3e1803a6e56654f224267d807894b6d16cd5f839da34'
AND (
token = '9r8YGVkaaLuuCUzgftVBu0+nwIkYCZsghld+EEP/DzI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)