UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '+yr9bDZtL4y4C2aYrHYoCanEgMvF4tWx2bNhnirV6v8='
WHERE
key_id = '27aee4d7661492246bde0b2ee3cdbc90661a638baf0feb65dd4f93fc09267943'
AND (
token = '+yr9bDZtL4y4C2aYrHYoCanEgMvF4tWx2bNhnirV6v8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)