UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0w6Bk2r5afbYM4ipnsVnf7oRAVPcDNb6Zld09PY6hCU='
WHERE
key_id = '4f728369685ad213437c0859ab3c7e805f781c438af2c7afaaee22189a847afc'
AND (
token = '0w6Bk2r5afbYM4ipnsVnf7oRAVPcDNb6Zld09PY6hCU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)