UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5L2DHXyO6QlgTKMLG2CKcuXPJP6BFtTstaLcMsxlfkU='
WHERE
key_id = 'b16cf5bd3771098bf76bcd3bddc6ed4b4b936e5d8ad310b94fe6fa5a27adf619'
AND (
token = '5L2DHXyO6QlgTKMLG2CKcuXPJP6BFtTstaLcMsxlfkU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)