UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '04Va1xLQ8FBoMPWm4M1onsYxXHyecBYUrXsKGYGeWWU='
WHERE
key_id = '346cde472bf5d8880e000746fa984fbd170cf76ce550ca00bb2215187e7713f2'
AND (
token = '04Va1xLQ8FBoMPWm4M1onsYxXHyecBYUrXsKGYGeWWU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)