UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3YETyMPyQ0REkc1U6VuEipErW1zBFTEaOCoJane9k84='
WHERE
key_id = '55ce11e5d4a296e78a3100f544f6c6532aef2767b3aeca92b5ab0f4699fe4bef'
AND (
token = '3YETyMPyQ0REkc1U6VuEipErW1zBFTEaOCoJane9k84='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)