UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QEY352QVcE6EOB1h9lTqoJPHW70JAtXjmUok36V/DWg='
WHERE
key_id = 'ff7fd4912e7b43939f87a1fe0c3885dd8c2cf92164ccd3bbc80e1c0b165680a0'
AND (
token = 'QEY352QVcE6EOB1h9lTqoJPHW70JAtXjmUok36V/DWg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)