UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZnW25Ew7DVqE4RlSkixo8UBXytkTd6MQwhAre7bLnQ4='
WHERE
key_id = '0b9b89ea3affca9e8e9d3c573a97f4d8c6b60428bf0f2e4365d0adeddc10793d'
AND (
token = 'ZnW25Ew7DVqE4RlSkixo8UBXytkTd6MQwhAre7bLnQ4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)