UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7J3hQaWTmi04BgAOLxRQ3YAurI36kriB7BGwNJdXZm4='
WHERE
key_id = 'fae16e5bdb291e72b6da07ec6f9b74876bbb787c73e6982c85ce0ddae49eb7cf'
AND (
token = '7J3hQaWTmi04BgAOLxRQ3YAurI36kriB7BGwNJdXZm4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)