UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'TI2ZNKnTT05njtK+CHR3yC9F42SrgsJBckflKoHmNNE='
WHERE
key_id = '8b9aa8f74c4f6cf6ec164b2f60acdbed7ebf2e6ba4a27a40304e3387313e2258'
AND (
token = 'TI2ZNKnTT05njtK+CHR3yC9F42SrgsJBckflKoHmNNE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)