UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'yhDQi3aR13PI75tD2czxUsPu5cgd3DXkavAOMH+xcEk='
WHERE
key_id = 'e1f669c35e8b4c8cebda0bedf178488e3809e4ccc56b31db1587e582928ec981'
AND (
token = 'yhDQi3aR13PI75tD2czxUsPu5cgd3DXkavAOMH+xcEk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)