UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7J8MgoispGje34BT++evAd43tx3iivj7KOfRpiBkjpM='
WHERE
key_id = 'e2d25b2eb3e224f81a040ed5b7a51019ed3475fa81fa9b4ae7ac729b910af497'
AND (
token = '7J8MgoispGje34BT++evAd43tx3iivj7KOfRpiBkjpM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)