UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KzSzRt3RZKbKAs2ygoF91ec0E4YK0BueFeX5XQBpewI='
WHERE
key_id = '57bd738f8837602089bc68d4e80650e7769b8c2106d922b765f91551c60cb23f'
AND (
token = 'KzSzRt3RZKbKAs2ygoF91ec0E4YK0BueFeX5XQBpewI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)