UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'PGlHsKq+3l+xMyZMoRAlE9weDQeBDDAWhRb2cjCyq+w='
WHERE
key_id = 'b04f97c3d4c402a71dbe57f9e7c3aba0568b623a73602be0b947ca477856299d'
AND (
token = 'PGlHsKq+3l+xMyZMoRAlE9weDQeBDDAWhRb2cjCyq+w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)