UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zKCSTr1xrJpv2TcGgAJHiRjPmVSBFByyOTd0jafJaMY='
WHERE
key_id = '5f7d5ac1c8ef139d3ffecd68f1b92c08dd02bf91ef8d47658352c3d00acf598f'
AND (
token = 'zKCSTr1xrJpv2TcGgAJHiRjPmVSBFByyOTd0jafJaMY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)