UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'aqGITOTg5AzDY15XgRzMzYh93H2J9bUstxzgzKecvu4='
WHERE
key_id = '07d42ffa412caae8a253223bef557a64a9f66f74fb89cc09edf49e73f2190cd3'
AND (
token = 'aqGITOTg5AzDY15XgRzMzYh93H2J9bUstxzgzKecvu4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)