UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'IUoe92A0vUaBI8pxYlnynKqXIglcE7TmpjIs5u2S6qI='
WHERE
key_id = '027c02918de9c59d3cd44be8a363b95cb306bdda045da3780338769dc497fbb7'
AND (
token = 'IUoe92A0vUaBI8pxYlnynKqXIglcE7TmpjIs5u2S6qI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)