UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'uogjODC7MvUaiqRB1Qpfo99KOCxrVu2144R9Y+/AKeA='
WHERE
key_id = '1004a914311508da6c6064996d94cafcd7d23de69aa5db90f65626a91d417e1b'
AND (
token = 'uogjODC7MvUaiqRB1Qpfo99KOCxrVu2144R9Y+/AKeA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)