UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'arMl8mDAQolay87HSvlyAqh9bs14BYbt4Xd7x0FtVX0='
WHERE
key_id = 'b0adca39c05885903d7937a7866ae58c80235bacecf21a0d2d287ec8063ec81f'
AND (
token = 'arMl8mDAQolay87HSvlyAqh9bs14BYbt4Xd7x0FtVX0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)