UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4fhQNMDLPL/FmozWkZFXfw6qTmgJTL8V6IHBAUAZTHk='
WHERE
key_id = 'cf7dc0e1194fa9c9d9daf3285c81715024106f82a2980d02ae7de96967df2174'
AND (
token = '4fhQNMDLPL/FmozWkZFXfw6qTmgJTL8V6IHBAUAZTHk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)