UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xekSR+fn6MtkGyP54oeL9FK/JnYH/naTYCqFmKLxiO0='
WHERE
key_id = 'a1d78cf64f7fef9c0617776bb0ea746767008947beb048649e485524f76a6b51'
AND (
token = 'xekSR+fn6MtkGyP54oeL9FK/JnYH/naTYCqFmKLxiO0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)