UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'PIIfhVTcUO7Q7Pj99U5f4Xb0UtX+KxzmUOlCS7PyaPk='
WHERE
key_id = '3bc8a5126d9549d47c65ca2212c659e82b3592cae55b282db1bd4462995366f0'
AND (
token = 'PIIfhVTcUO7Q7Pj99U5f4Xb0UtX+KxzmUOlCS7PyaPk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)