UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'S9fTPfYpZEkHNPkfBoWIRpgF/8gTSJRkaziU8ac5Vps='
WHERE
key_id = 'd9cb26118c10b4c06c43044d2f451e3a093c760aed01bd94b033d201a84b0b72'
AND (
token = 'S9fTPfYpZEkHNPkfBoWIRpgF/8gTSJRkaziU8ac5Vps='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)