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