UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '+aiWfIhDTiWblArw4JVJpsq1lmzNK24/qOH4j9z/27M='
WHERE
key_id = 'f7bf605cfeb2caa87ee956589197d76daa51cf43e3e3ef054da85ac939234372'
AND (
token = '+aiWfIhDTiWblArw4JVJpsq1lmzNK24/qOH4j9z/27M='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)