UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'OeRmoyB5pOtqkvxBNggp8W3cZyOcW1r6iZW7V9z1ofk='
WHERE
key_id = '9e77c872fe49d1414151f4881edb72139abfb896d577124e08ce4c35da6ca0b3'
AND (
token = 'OeRmoyB5pOtqkvxBNggp8W3cZyOcW1r6iZW7V9z1ofk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)