UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'W7itpeIvztxPUJhE3m1GanRkN+ay5hnHl9MSyInqeDs='
WHERE
key_id = 'd9fa7aff6d9ceedac386b290d56a2b45dc0e5bc6fe5e9ba8921165485fd30a6e'
AND (
token = 'W7itpeIvztxPUJhE3m1GanRkN+ay5hnHl9MSyInqeDs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)