UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'syqmIqBhX6+UZt68X3qeZrHk/UdWdgxpAMl+zzHio+E='
WHERE
key_id = '5a23a6dcae6a4435baedd7a8a4e773354632b30890c3ce720d42a3223bbe01b7'
AND (
token = 'syqmIqBhX6+UZt68X3qeZrHk/UdWdgxpAMl+zzHio+E='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)