UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ROaPv7avhBv5Wco2KzAYu74ZNm9r3lLzyUv5KPbW/L8='
WHERE
key_id = '78203b059c64ccdef6eb897e13c5a30983f050c8c937831e04591395b674be3a'
AND (
token = 'ROaPv7avhBv5Wco2KzAYu74ZNm9r3lLzyUv5KPbW/L8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)